Problem Note 60605: Using the Load Data to LASR directive with the "Replace entire table" option generates a "Libref is not assigned" error
 |  |  |  |  |
When you use the Load Data to LASR directive with Replace entire table in the target table options, SAS® Data Loader for Hadoop is assigning a libref using the LASR TAG for Hive schema name.
The generated code is de-assigning the LASR libref after the PROC DATASETS DELETE statement. If the LASR TAG and libref have the same name in the LASR server definition in SAS® Management Console, the Load Data to LASR directive fails. An error message similar to the following is reported in the SAS log:
ERROR: Libref MYLIB is not assigned.
To circumvent the problem, change the name of LASR TAG to be different from that of the LASR libref.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Loader for Hadoop | 64-bit Enabled Solaris | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 |
| 64-bit Enabled AIX | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Ultimate x64 | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Ultimate 32 bit | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Professional 32 bit | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Home Premium x64 | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Home Premium 32 bit | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Enterprise 32 bit | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Std | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Std | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Datacenter | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 for x64 | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 R2 | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 10 | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro x64 | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro 32-bit | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro 32-bit | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise x64 | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise 32-bit | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft® Windows® for x64 | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| HP-UX IPF | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Linux for x64 | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Solaris for x64 | 3.1 | 3.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
A fix for this issue for SAS Data Loader Mid-Tier 3.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B3I.html#60605| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-10-18 10:37:42 |
| Date Created: | 2017-06-12 11:20:05 |